# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2021年10月09日
"""
import pandas as pd

path = '../数据文件/课件013-014/筛选.xlsx'
data = pd.read_excel(path, index_col='序号', sheet_name='Sheet1')

# con = data['地址'].str.contains('信阳市')

con = data['地址'].str.contains('[a-cA-C]座')

print(data[con])
